Oracle Fusion SQL MOC
|
2 min read
Oracle Fusion SQL MOC
Structure Note in the Zettelkasten — the entry point for every Oracle Fusion SQL query in this vault.
Each query note links back here withOracle Fusion SQL MOC, so the Dataview at the bottom collects it automatically.
Scope: Oracle Fusion Cloud only. EBS-era Open University queries (private/ERP/,private/OP/) are a separate lineage — see ERP.
Procurement / P2P
- Oracle Fusion - SQL Query for Requisitions — requisition header/line extract.
- Energix FDS - Open POs Amounts — open PO amounts, BIP-driven FDS.
- Energix - P2P Setups — P2P configuration with validation queries.
- Energix - P2P FDS - Contract DFF — contract DFF extract.
- PO Notification - Including Budget data — PO notification queries.
- Energix - P2P Gap analysis — gap analysis with supporting queries.
Finance / GL / Projects
- Orecle Fusion - Query for GL to Project cost — GL ↔ project cost reconciliation.
- Energix - Closing Cost Period — cost period close checks.
Security & Access
- Oracle Fusion - Queries for security BIP — BIP security / role queries.
- Orecle Fusion - Query for Data Access — data access & security context.
- Oracle Fusion - Query for Cost Center Manger — cost centre manager resolution.
- Oracle Assistant V3 - Row-Level Document Security — row-level document security SQL.
Reference data
- Oracle Fusion - SQL Query for Business Units — business unit lookup.
- Oracle Fusion - Users and Email report — user / email extract.
- Oracle Fusion - Frequently HCM tables — common HCM tables (reference for writing queries).
Technique / how-to
- Oracle Fusion - How to retrieve custom object data — querying custom objects.
- Oracle Fusion - Create an alert (busrting) — BIP bursting alerts driven by SQL.
All linked query notes (auto)
Related
- ERP · Energix · Purchasing
- Energix - P2P Implementation Project — P2P implementation hub
- P2P MOC — purchasing Zettelkasten cluster
קישורים (Zettelkasten)
- Structure Note לכל שאילתות ה-SQL של Oracle Fusion בכספת.
- MOC אחות: P2P MOC · Energix - P2P Implementation Project
- מושג יסוד: Oracle Fusion - PP2 Procure to pay — מודל ה-P2P שרוב השאילתות נשענות עליו.
- חלק מ: ERP